﻿CREATE TABLE [dbo].[tblTransaction] (
    [TransactionID]         INT           IDENTITY (1, 1) NOT NULL,
    [TransactionTypeCode]   CHAR (1)      NOT NULL,
	AccountID int not null,
	ProcessorCode char not null,
    [Amount]                MONEY         NOT NULL,
	[CreateDate]	smalldatetime not null,
	[PostingDate]	smalldatetime null,
    [TransactionStatusCode] CHAR (1)      NOT NULL,
    [BankCheckNumber]       INT           NULL,
    [RelatedTransactionID]  INT           NULL,
	[OrderID]	int	null,
	[CardAuthorization]	nvarchar(20) null,
	[CardAuthorizationDate] smalldatetime null,
	[ProcessorTransactionID] nvarchar(40) null
);

